Labels:text | screenshot | menu | font OCR: Time key Time Dimension Customer Dimension Join Customer key Product key Product Dimension Promotion Dimension Join Promotion key Salesperson key Join Salesperson Status Dimension Join Status key Dimension Quantity sold THIS Extended list price MINUS Total allowances MINUS Total discounts EQUALS Extended net price = REVENUE SHOULD WE STORE IT? YES! Figure 3. A typical customer billing fact table in which the extended net price can be derived from the other quantities, but nevertheless we want to store it in the table.
